Fast EDA

Dataset statistics

Number of variables	45
Number of observations	683788
Missing cells	253521
Missing cells (%)	0.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 GiB
Average record size in memory	1.8 KiB

Variable types

NUM	19
CAT	17
BOOL	9

Reproduction

Analysis started	2020-06-07 13:19:22.651867
Analysis finished	2020-06-07 13:25:15.319605
Duration	5 minutes and 52.67 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`state` has constant value "New York"	Constant
`created_at` has a high cardinality: 483 distinct values	High cardinality
`spc_latin` has a high cardinality: 132 distinct values	High cardinality
`spc_common` has a high cardinality: 132 distinct values	High cardinality
`problems` has a high cardinality: 232 distinct values	High cardinality
`address` has a high cardinality: 408701 distinct values	High cardinality
`nta` has a high cardinality: 188 distinct values	High cardinality
`nta_name` has a high cardinality: 188 distinct values	High cardinality
`borocode` is highly correlated with `community board` and 3 other fields	High correlation
`community board` is highly correlated with `borocode` and 3 other fields	High correlation
`st_senate` is highly correlated with `st_assem`	High correlation
`st_assem` is highly correlated with `st_senate`	High correlation
`boro_ct` is highly correlated with `community board` and 3 other fields	High correlation
`x_sp` is highly correlated with `longitude`	High correlation
`longitude` is highly correlated with `x_sp`	High correlation
`y_sp` is highly correlated with `latitude`	High correlation
`latitude` is highly correlated with `y_sp`	High correlation
`council district` is highly correlated with `cncldist`	High correlation
`cncldist` is highly correlated with `council district`	High correlation
`bin` is highly correlated with `community board` and 3 other fields	High correlation
`bbl` is highly correlated with `community board` and 3 other fields	High correlation
`borough` is highly correlated with `zip_city`	High correlation
`zip_city` is highly correlated with `borough`	High correlation
`health` has 31616 (4.6%) missing values	Missing
`spc_latin` has 31619 (4.6%) missing values	Missing
`spc_common` has 31619 (4.6%) missing values	Missing
`steward` has 31615 (4.6%) missing values	Missing
`guards` has 31616 (4.6%) missing values	Missing
`sidewalk` has 31616 (4.6%) missing values	Missing
`problems` has 31664 (4.6%) missing values	Missing
`bin` has 9559 (1.4%) missing values	Missing
`bbl` has 9559 (1.4%) missing values	Missing
`tree_id` has unique values	Unique
`tree_dbh` has 17932 (2.6%) zeros	Zeros
`stump_diam` has 666134 (97.4%) zeros	Zeros

tree_id
Real number (ℝ_≥0)

UNIQUE

Distinct count	683788
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	365205.01108530717
Minimum	3
Maximum	722694
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	3
5-th percentile	38056.35
Q1	186582.75
median	366214.5
Q3	546170.25
95-th percentile	687716.65
Maximum	722694
Range	722691
Interquartile range (IQR)	359587.5

Descriptive statistics

Standard deviation	208122.0929
Coefficient of variation (CV)	0.5698774293
Kurtosis	-1.192862994
Mean	365205.0111
Median Absolute Deviation (MAD)	179812.5
Skewness	-0.01716124126
Sum	2.497228041e+11
Variance	4.331480555e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2047	1	< 0.1%
638877	1	< 0.1%
626587	1	< 0.1%
624538	1	< 0.1%
630681	1	< 0.1%
628632	1	< 0.1%
651159	1	< 0.1%
649110	1	< 0.1%
655253	1	< 0.1%
653204	1	< 0.1%
642963	1	< 0.1%
640914	1	< 0.1%
647057	1	< 0.1%
645008	1	< 0.1%
601999	1	< 0.1%
599950	1	< 0.1%
606093	1	< 0.1%
604044	1	< 0.1%
593803	1	< 0.1%
636828	1	< 0.1%
632734	1	< 0.1%
597897	1	< 0.1%
634783	1	< 0.1%
577459	1	< 0.1%
575410	1	< 0.1%
Other values (683763)	683763	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
722694	1	< 0.1%
722693	1	< 0.1%
722692	1	< 0.1%
722691	1	< 0.1%
722690	1	< 0.1%
722689	1	< 0.1%
722688	1	< 0.1%
722687	1	< 0.1%
722686	1	< 0.1%
722685	1	< 0.1%

block_id
Real number (ℝ_≥0)

Distinct count	101390
Unique (%)	14.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	313793.0962359679
Minimum	100002
Maximum	999999
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	100002
5-th percentile	107430
Q1	221556
median	319967
Q3	404624
95-th percentile	510007
Maximum	999999
Range	899997
Interquartile range (IQR)	183068

Descriptive statistics

Standard deviation	114839.0243
Coefficient of variation (CV)	0.3659705255
Kurtosis	-0.5123830828
Mean	313793.0962
Median Absolute Deviation (MAD)	91359
Skewness	0.08163277621
Sum	2.145679537e+11
Variance	1.31880015e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
204850	450	0.1%
602362	358	0.1%
208115	250	< 0.1%
506756	206	< 0.1%
233208	197	< 0.1%
340498	195	< 0.1%
111902	178	< 0.1%
302421	159	< 0.1%
501930	145	< 0.1%
340497	135	< 0.1%
404057	133	< 0.1%
412069	132	< 0.1%
208130	129	< 0.1%
313163	115	< 0.1%
203224	112	< 0.1%
340200	107	< 0.1%
215490	107	< 0.1%
233203	105	< 0.1%
415097	103	< 0.1%
111782	100	< 0.1%
507767	100	< 0.1%
502629	97	< 0.1%
325867	93	< 0.1%
515723	93	< 0.1%
233200	93	< 0.1%
Other values (101365)	679896	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100002	4	< 0.1%
100003	14	< 0.1%
100004	3	< 0.1%
100005	4	< 0.1%
100014	2	< 0.1%
100015	5	< 0.1%
100016	5	< 0.1%
100018	5	< 0.1%
100019	2	< 0.1%
100028	5	< 0.1%

Value	Count	Frequency (%)
999999	5	< 0.1%
603084	1	< 0.1%
603083	3	< 0.1%
603082	6	< 0.1%
603081	6	< 0.1%
603077	9	< 0.1%
603075	4	< 0.1%
603074	36	< 0.1%
603073	34	< 0.1%
603072	35	< 0.1%

created_at
Categorical

HIGH CARDINALITY

Distinct count	483
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

10/27/2015	6852
10/13/2015	6676
10/26/2015	6258
10/29/2015	6223
10/15/2015	6085
Other values (478)	651694

Value	Count	Frequency (%)
10/27/2015	6852	1.0%
10/13/2015	6676	1.0%
10/26/2015	6258	0.9%
10/29/2015	6223	0.9%
10/15/2015	6085	0.9%
11/03/2015	6028	0.9%
10/14/2015	6010	0.9%
10/30/2015	5834	0.9%
10/20/2015	5677	0.8%
10/22/2015	5368	0.8%
11/02/2015	5322	0.8%
10/16/2015	5151	0.8%
10/23/2015	5069	0.7%
11/04/2015	5065	0.7%
10/07/2015	5027	0.7%
10/10/2015	4919	0.7%
11/05/2015	4780	0.7%
10/21/2015	4542	0.7%
09/25/2015	4362	0.6%
10/19/2015	4319	0.6%
10/28/2015	4316	0.6%
11/18/2015	4248	0.6%
10/12/2015	4219	0.6%
09/23/2015	4169	0.6%
10/08/2015	4164	0.6%
Other values (458)	553105	80.9%

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Overview of Unicode Properties

Unique unicode characters	11
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	1498005	21.9%
/	1367576	20.0%
1	1328543	19.4%
2	1031513	15.1%
5	599997	8.8%
6	317723	4.6%
8	185721	2.7%
9	178144	2.6%
7	160138	2.3%
3	106196	1.6%
4	64324	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5470304	80.0%
Other Punctuation	1367576	20.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	1498005	27.4%
1	1328543	24.3%
2	1031513	18.9%
5	599997	11.0%
6	317723	5.8%
8	185721	3.4%
9	178144	3.3%
7	160138	2.9%
3	106196	1.9%
4	64324	1.2%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	1367576	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6837880	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	1498005	21.9%
/	1367576	20.0%
1	1328543	19.4%
2	1031513	15.1%
5	599997	8.8%
6	317723	4.6%
8	185721	2.7%
9	178144	2.6%
7	160138	2.3%
3	106196	1.6%
4	64324	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6837880	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	1498005	21.9%
/	1367576	20.0%
1	1328543	19.4%
2	1031513	15.1%
5	599997	8.8%
6	317723	4.6%
8	185721	2.7%
9	178144	2.6%
7	160138	2.3%
3	106196	1.6%
4	64324	0.9%

tree_dbh
Real number (ℝ_≥0)

ZEROS

Distinct count	146
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.27978701000895
Minimum	0
Maximum	450
Zeros	17932
Zeros (%)	2.6%
Memory size	5.2 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
median	9
Q3	16
95-th percentile	28
Maximum	450
Range	450
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.723042269
Coefficient of variation (CV)	0.7733339522
Kurtosis	46.97759883
Mean	11.27978701
Median Absolute Deviation (MAD)	5
Skewness	2.429472373
Sum	7712983
Variance	76.09146642

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	60372	8.8%
3	54454	8.0%
2	41977	6.1%
5	41642	6.1%
11	37978	5.6%
6	36519	5.3%
7	30862	4.5%
8	30828	4.5%
10	29672	4.3%
9	28903	4.2%
12	25853	3.8%
13	24441	3.6%
14	21827	3.2%
15	19643	2.9%
18	19276	2.8%
0	17932	2.6%
16	17813	2.6%
17	15698	2.3%
19	12655	1.9%
20	11428	1.7%
21	10645	1.6%
22	10259	1.5%
25	10235	1.5%
23	9155	1.3%
24	8531	1.2%
Other values (121)	55190	8.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	17932	2.6%
1	2899	0.4%
2	41977	6.1%
3	54454	8.0%
4	60372	8.8%
5	41642	6.1%
6	36519	5.3%
7	30862	4.5%
8	30828	4.5%
9	28903	4.2%

Value	Count	Frequency (%)
450	1	< 0.1%
425	1	< 0.1%
389	1	< 0.1%
318	2	< 0.1%
298	1	< 0.1%
293	1	< 0.1%
291	1	< 0.1%
282	1	< 0.1%
281	1	< 0.1%
266	1	< 0.1%

stump_diam
Real number (ℝ_≥0)

ZEROS

Distinct count	100
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.43246298560372515
Minimum	0
Maximum	140
Zeros	666134
Zeros (%)	97.4%
Memory size	5.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	140
Range	140
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.29024074
Coefficient of variation (CV)	7.608144164
Kurtosis	145.298141
Mean	0.4324629856
Median Absolute Deviation (MAD)	0
Skewness	10.36345045
Sum	295713
Variance	10.82568413

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	666134	97.4%
4	966	0.1%
5	939	0.1%
3	779	0.1%
6	754	0.1%
12	717	0.1%
10	716	0.1%
14	660	0.1%
8	660	0.1%
15	648	0.1%
7	612	0.1%
13	609	0.1%
20	572	0.1%
18	567	0.1%
16	557	0.1%
9	530	0.1%
17	526	0.1%
11	525	0.1%
22	426	0.1%
19	410	0.1%
24	404	0.1%
25	398	0.1%
2	363	0.1%
21	349	0.1%
30	338	< 0.1%
Other values (75)	3629	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	666134	97.4%
1	106	< 0.1%
2	363	0.1%
3	779	0.1%
4	966	0.1%
5	939	0.1%
6	754	0.1%
7	612	0.1%
8	660	0.1%
9	530	0.1%

Value	Count	Frequency (%)
140	1	< 0.1%
134	1	< 0.1%
131	1	< 0.1%
125	1	< 0.1%
120	1	< 0.1%
118	1	< 0.1%
115	1	< 0.1%
109	1	< 0.1%
107	1	< 0.1%
104	1	< 0.1%

curb_loc
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

OnCurb	656896
OffsetFromCurb	26892

Value	Count	Frequency (%)
OnCurb	656896	96.1%
OffsetFromCurb	26892	3.9%

Length

Max length	14
Median length	6
Mean length	6.314623831
Min length	6

Overview of Unicode Properties

Unique unicode characters	13
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
r	710680	16.5%
O	683788	15.8%
C	683788	15.8%
u	683788	15.8%
b	683788	15.8%
n	656896	15.2%
f	53784	1.2%
s	26892	0.6%
e	26892	0.6%
t	26892	0.6%
F	26892	0.6%
o	26892	0.6%
m	26892	0.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2923396	67.7%
Uppercase Letter	1394468	32.3%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
O	683788	49.0%
C	683788	49.0%
F	26892	1.9%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
r	710680	24.3%
u	683788	23.4%
b	683788	23.4%
n	656896	22.5%
f	53784	1.8%
s	26892	0.9%
e	26892	0.9%
t	26892	0.9%
o	26892	0.9%
m	26892	0.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4317864	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
r	710680	16.5%
O	683788	15.8%
C	683788	15.8%
u	683788	15.8%
b	683788	15.8%
n	656896	15.2%
f	53784	1.2%
s	26892	0.6%
e	26892	0.6%
t	26892	0.6%
F	26892	0.6%
o	26892	0.6%
m	26892	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4317864	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
r	710680	16.5%
O	683788	15.8%
C	683788	15.8%
u	683788	15.8%
b	683788	15.8%
n	656896	15.2%
f	53784	1.2%
s	26892	0.6%
e	26892	0.6%
t	26892	0.6%
F	26892	0.6%
o	26892	0.6%
m	26892	0.6%

status
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

Alive	652173
Stump	17654
Dead	13961

Value	Count	Frequency (%)
Alive	652173	95.4%
Stump	17654	2.6%
Dead	13961	2.0%

Length

Max length	5
Median length	5
Mean length	4.979582853
Min length	4

Overview of Unicode Properties

Unique unicode characters	13
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	666134	19.6%
A	652173	19.2%
l	652173	19.2%
i	652173	19.2%
v	652173	19.2%
S	17654	0.5%
t	17654	0.5%
u	17654	0.5%
m	17654	0.5%
p	17654	0.5%
D	13961	0.4%
a	13961	0.4%
d	13961	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2721191	79.9%
Uppercase Letter	683788	20.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	652173	95.4%
S	17654	2.6%
D	13961	2.0%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	666134	24.5%
l	652173	24.0%
i	652173	24.0%
v	652173	24.0%
t	17654	0.6%
u	17654	0.6%
m	17654	0.6%
p	17654	0.6%
a	13961	0.5%
d	13961	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3404979	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
e	666134	19.6%
A	652173	19.2%
l	652173	19.2%
i	652173	19.2%
v	652173	19.2%
S	17654	0.5%
t	17654	0.5%
u	17654	0.5%
m	17654	0.5%
p	17654	0.5%
D	13961	0.4%
a	13961	0.4%
d	13961	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3404979	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	666134	19.6%
A	652173	19.2%
l	652173	19.2%
i	652173	19.2%
v	652173	19.2%
S	17654	0.5%
t	17654	0.5%
u	17654	0.5%
m	17654	0.5%
p	17654	0.5%
D	13961	0.4%
a	13961	0.4%
d	13961	0.4%

health
Categorical

MISSING

Distinct count	3
Unique (%)	< 0.1%
Missing	31616
Missing (%)	4.6%
Memory size	5.2 MiB

Good	528850
Fair	96504
Poor	26818

Value	Count	Frequency (%)
Good	528850	77.3%
Fair	96504	14.1%
Poor	26818	3.9%
(Missing)	31616	4.6%

Length

Max length	4
Median length	4
Mean length	3.953763447
Min length	3

Overview of Unicode Properties

Unique unicode characters	9
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
o	1111336	41.1%
G	528850	19.6%
d	528850	19.6%
a	128120	4.7%
r	123322	4.6%
F	96504	3.6%
i	96504	3.6%
n	63232	2.3%
P	26818	1.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2051364	75.9%
Uppercase Letter	652172	24.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
G	528850	81.1%
F	96504	14.8%
P	26818	4.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
o	1111336	54.2%
d	528850	25.8%
a	128120	6.2%
r	123322	6.0%
i	96504	4.7%
n	63232	3.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2703536	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
o	1111336	41.1%
G	528850	19.6%
d	528850	19.6%
a	128120	4.7%
r	123322	4.6%
F	96504	3.6%
i	96504	3.6%
n	63232	2.3%
P	26818	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2703536	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
o	1111336	41.1%
G	528850	19.6%
d	528850	19.6%
a	128120	4.7%
r	123322	4.6%
F	96504	3.6%
i	96504	3.6%
n	63232	2.3%
P	26818	1.0%

spc_latin
Categorical

HIGH CARDINALITY
MISSING

Distinct count	132
Unique (%)	< 0.1%
Missing	31619
Missing (%)	4.6%
Memory size	5.2 MiB

Platanus x acerifolia	87014
Gleditsia triacanthos var. inermis	64264
Pyrus calleryana	58931
Quercus palustris	53185
Acer platanoides	34189
Other values (127)	354586

Value	Count	Frequency (%)
Platanus x acerifolia	87014	12.7%
Gleditsia triacanthos var. inermis	64264	9.4%
Pyrus calleryana	58931	8.6%
Quercus palustris	53185	7.8%
Acer platanoides	34189	5.0%
Tilia cordata	29742	4.3%
Prunus	29279	4.3%
Zelkova serrata	29258	4.3%
Ginkgo biloba	21024	3.1%
Styphnolobium japonicum	19338	2.8%
Acer rubrum	17246	2.5%
Fraxinus pennsylvanica	16251	2.4%
Tilia americana	13530	2.0%
Acer saccharinum	12277	1.8%
Liquidambar styraciflua	10657	1.6%
Quercus rubra	8400	1.2%
Tilia tomentosa	7995	1.2%
Ulmus americana	7975	1.2%
Acer	7080	1.0%
Prunus cerasifera	6879	1.0%
Quercus bicolor	6598	1.0%
Acer platanoides 'Crimson King'	5923	0.9%
Ulmus parvifolia	5345	0.8%
Prunus virginiana	4888	0.7%
Syringa reticulata	4568	0.7%
Other values (107)	90333	13.2%
(Missing)	31619	4.6%

Length

Max length	34
Median length	16
Mean length	17.35580911
Min length	3

Overview of Unicode Properties

Unique unicode characters	50
Unique unicode categories (?)	4
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
a	1591747	13.4%
i	1049571	8.8%
r	993219	8.4%
s	835821	7.0%
	829362	7.0%
l	692257	5.8%
e	689988	5.8%
u	685213	5.8%
n	683024	5.8%
c	584030	4.9%
t	539091	4.5%
o	452769	3.8%
m	230336	1.9%
p	191639	1.6%
P	190226	1.6%
y	180741	1.5%
d	179143	1.5%
v	124304	1.0%
b	117471	1.0%
f	114353	1.0%
h	111247	0.9%
x	109411	0.9%
A	93024	0.8%
G	88652	0.7%
Q	82867	0.7%
Other values (25)	428188	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10297866	86.8%
Space Separator	829362	7.0%
Uppercase Letter	664015	5.6%
Other Punctuation	76451	0.6%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
P	190226	28.6%
A	93024	14.0%
G	88652	13.4%
Q	82867	12.5%
T	53125	8.0%
Z	29258	4.4%
C	26340	4.0%
S	25213	3.8%
F	20379	3.1%
U	14915	2.2%
L	12221	1.8%
M	10930	1.6%
K	9642	1.5%
R	1784	0.3%
B	1400	0.2%
J	1396	0.2%
O	1081	0.2%
E	915	0.1%
N	288	< 0.1%
H	221	< 0.1%
I	138	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
a	1591747	15.5%
i	1049571	10.2%
r	993219	9.6%
s	835821	8.1%
l	692257	6.7%
e	689988	6.7%
u	685213	6.7%
n	683024	6.6%
c	584030	5.7%
t	539091	5.2%
o	452769	4.4%
m	230336	2.2%
p	191639	1.9%
y	180741	1.8%
d	179143	1.7%
v	124304	1.2%
b	117471	1.1%
f	114353	1.1%
h	111247	1.1%
x	109411	1.1%
k	54201	0.5%
g	52562	0.5%
j	21558	0.2%
q	13677	0.1%
z	248	< 0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	829362	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
.	64605	84.5%
'	11846	15.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10961881	92.4%
Common	905813	7.6%

Most frequent Latin characters

Value	Count	Frequency (%)
a	1591747	14.5%
i	1049571	9.6%
r	993219	9.1%
s	835821	7.6%
l	692257	6.3%
e	689988	6.3%
u	685213	6.3%
n	683024	6.2%
c	584030	5.3%
t	539091	4.9%
o	452769	4.1%
m	230336	2.1%
p	191639	1.7%
P	190226	1.7%
y	180741	1.6%
d	179143	1.6%
v	124304	1.1%
b	117471	1.1%
f	114353	1.0%
h	111247	1.0%
x	109411	1.0%
A	93024	0.8%
G	88652	0.8%
Q	82867	0.8%
k	54201	0.5%
Other values (22)	297536	2.7%

Most frequent Common characters

Value	Count	Frequency (%)
	829362	91.6%
.	64605	7.1%
'	11846	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11867694	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
a	1591747	13.4%
i	1049571	8.8%
r	993219	8.4%
s	835821	7.0%
	829362	7.0%
l	692257	5.8%
e	689988	5.8%
u	685213	5.8%
n	683024	5.8%
c	584030	4.9%
t	539091	4.5%
o	452769	3.8%
m	230336	1.9%
p	191639	1.6%
P	190226	1.6%
y	180741	1.5%
d	179143	1.5%
v	124304	1.0%
b	117471	1.0%
f	114353	1.0%
h	111247	0.9%
x	109411	0.9%
A	93024	0.8%
G	88652	0.7%
Q	82867	0.7%
Other values (25)	428188	3.6%

spc_common
Categorical

HIGH CARDINALITY
MISSING

Distinct count	132
Unique (%)	< 0.1%
Missing	31619
Missing (%)	4.6%
Memory size	5.2 MiB

London planetree	87014
honeylocust	64264
Callery pear	58931
pin oak	53185
Norway maple	34189
Other values (127)	354586

Value	Count	Frequency (%)
London planetree	87014	12.7%
honeylocust	64264	9.4%
Callery pear	58931	8.6%
pin oak	53185	7.8%
Norway maple	34189	5.0%
littleleaf linden	29742	4.3%
cherry	29279	4.3%
Japanese zelkova	29258	4.3%
ginkgo	21024	3.1%
Sophora	19338	2.8%
red maple	17246	2.5%
green ash	16251	2.4%
American linden	13530	2.0%
silver maple	12277	1.8%
sweetgum	10657	1.6%
northern red oak	8400	1.2%
silver linden	7995	1.2%
American elm	7975	1.2%
maple	7080	1.0%
purple-leaf plum	6879	1.0%
swamp white oak	6598	1.0%
crimson king maple	5923	0.9%
Chinese elm	5345	0.8%
'Schubert' chokecherry	4888	0.7%
Japanese tree lilac	4568	0.7%
Other values (107)	90333	13.2%
(Missing)	31619	4.6%

Length

Max length	22
Median length	12
Mean length	11.55410449
Min length	3

Overview of Unicode Properties

Unique unicode characters	42
Unique unicode categories (?)	5
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	1090341	13.8%
a	729247	9.2%
n	725101	9.2%
l	632093	8.0%
o	590406	7.5%
r	548056	6.9%
	515959	6.5%
p	390862	4.9%
t	289664	3.7%
i	261377	3.3%
y	209494	2.7%
h	205759	2.6%
s	203791	2.6%
d	200183	2.5%
c	187125	2.4%
m	182864	2.3%
k	159730	2.0%
u	123827	1.6%
g	93164	1.2%
L	87014	1.1%
w	86914	1.1%
C	66211	0.8%
v	53732	0.7%
f	46255	0.6%
b	36269	0.5%
Other values (17)	185120	2.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7075976	89.6%
Space Separator	515959	6.5%
Uppercase Letter	289070	3.7%
Other Punctuation	11263	0.1%
Dash Punctuation	8290	0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	1090341	15.4%
a	729247	10.3%
n	725101	10.2%
l	632093	8.9%
o	590406	8.3%
r	548056	7.7%
p	390862	5.5%
t	289664	4.1%
i	261377	3.7%
y	209494	3.0%
h	205759	2.9%
s	203791	2.9%
d	200183	2.8%
c	187125	2.6%
m	182864	2.6%
k	159730	2.3%
u	123827	1.7%
g	93164	1.3%
w	86914	1.2%
v	53732	0.8%
f	46255	0.7%
b	36269	0.5%
z	29575	0.4%
q	83	< 0.1%
x	64	< 0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	515959	100.0%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
L	87014	30.1%
C	66211	22.9%
J	35774	12.4%
N	34544	12.0%
A	29293	10.1%
S	27392	9.5%
E	3915	1.4%
K	3843	1.3%
O	323	0.1%
T	317	0.1%
P	277	0.1%
D	85	< 0.1%
H	72	< 0.1%
V	10	< 0.1%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	8290	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
'	11263	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7365046	93.2%
Common	535512	6.8%

Most frequent Latin characters

Value	Count	Frequency (%)
e	1090341	14.8%
a	729247	9.9%
n	725101	9.8%
l	632093	8.6%
o	590406	8.0%
r	548056	7.4%
p	390862	5.3%
t	289664	3.9%
i	261377	3.5%
y	209494	2.8%
h	205759	2.8%
s	203791	2.8%
d	200183	2.7%
c	187125	2.5%
m	182864	2.5%
k	159730	2.2%
u	123827	1.7%
g	93164	1.3%
L	87014	1.2%
w	86914	1.2%
C	66211	0.9%
v	53732	0.7%
f	46255	0.6%
b	36269	0.5%
J	35774	0.5%
Other values (14)	129793	1.8%

Most frequent Common characters

Value	Count	Frequency (%)
	515959	96.3%
'	11263	2.1%
-	8290	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7900558	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	1090341	13.8%
a	729247	9.2%
n	725101	9.2%
l	632093	8.0%
o	590406	7.5%
r	548056	6.9%
	515959	6.5%
p	390862	4.9%
t	289664	3.7%
i	261377	3.3%
y	209494	2.7%
h	205759	2.6%
s	203791	2.6%
d	200183	2.5%
c	187125	2.4%
m	182864	2.3%
k	159730	2.0%
u	123827	1.6%
g	93164	1.2%
L	87014	1.1%
w	86914	1.1%
C	66211	0.8%
v	53732	0.7%
f	46255	0.6%
b	36269	0.5%
Other values (17)	185120	2.3%

steward
Categorical

MISSING

Distinct count	4
Unique (%)	< 0.1%
Missing	31615
Missing (%)	4.6%
Memory size	5.2 MiB

None	487823
1or2	143557
3or4	19183
4orMore	1610

Value	Count	Frequency (%)
None	487823	71.3%
1or2	143557	21.0%
3or4	19183	2.8%
4orMore	1610	0.2%
(Missing)	31615	4.6%

Length

Max length	7
Median length	4
Mean length	3.960828502
Min length	3

Overview of Unicode Properties

Unique unicode characters	11
Unique unicode categories (?)	3
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
o	653783	24.1%
n	551053	20.3%
e	489433	18.1%
N	487823	18.0%
r	165960	6.1%
1	143557	5.3%
2	143557	5.3%
a	31615	1.2%
4	20793	0.8%
3	19183	0.7%
M	1610	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1891844	69.9%
Uppercase Letter	489433	18.1%
Decimal Number	327090	12.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	487823	99.7%
M	1610	0.3%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
o	653783	34.6%
n	551053	29.1%
e	489433	25.9%
r	165960	8.8%
a	31615	1.7%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	143557	43.9%
2	143557	43.9%
4	20793	6.4%
3	19183	5.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2381277	87.9%
Common	327090	12.1%

Most frequent Latin characters

Value	Count	Frequency (%)
o	653783	27.5%
n	551053	23.1%
e	489433	20.6%
N	487823	20.5%
r	165960	7.0%
a	31615	1.3%
M	1610	0.1%

Most frequent Common characters

Value	Count	Frequency (%)
1	143557	43.9%
2	143557	43.9%
4	20793	6.4%
3	19183	5.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2708367	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
o	653783	24.1%
n	551053	20.3%
e	489433	18.1%
N	487823	18.0%
r	165960	6.1%
1	143557	5.3%
2	143557	5.3%
a	31615	1.2%
4	20793	0.8%
3	19183	0.7%
M	1610	0.1%

guards
Categorical

MISSING

Distinct count	4
Unique (%)	< 0.1%
Missing	31616
Missing (%)	4.6%
Memory size	5.2 MiB

None	572306
Helpful	51866
Harmful	20252
Unsure	7748

Value	Count	Frequency (%)
None	572306	83.7%
Helpful	51866	7.6%
Harmful	20252	3.0%
Unsure	7748	1.1%
(Missing)	31616	4.6%

Length

Max length	7
Median length	4
Mean length	4.292830526
Min length	3

Overview of Unicode Properties

Unique unicode characters	14
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	643286	21.9%
e	631920	21.5%
N	572306	19.5%
o	572306	19.5%
l	123984	4.2%
u	79866	2.7%
H	72118	2.5%
f	72118	2.5%
a	51868	1.8%
p	51866	1.8%
r	28000	1.0%
m	20252	0.7%
U	7748	0.3%
s	7748	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2283214	77.8%
Uppercase Letter	652172	22.2%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	572306	87.8%
H	72118	11.1%
U	7748	1.2%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	643286	28.2%
e	631920	27.7%
o	572306	25.1%
l	123984	5.4%
u	79866	3.5%
f	72118	3.2%
a	51868	2.3%
p	51866	2.3%
r	28000	1.2%
m	20252	0.9%
s	7748	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2935386	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
n	643286	21.9%
e	631920	21.5%
N	572306	19.5%
o	572306	19.5%
l	123984	4.2%
u	79866	2.7%
H	72118	2.5%
f	72118	2.5%
a	51868	1.8%
p	51866	1.8%
r	28000	1.0%
m	20252	0.7%
U	7748	0.3%
s	7748	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2935386	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	643286	21.9%
e	631920	21.5%
N	572306	19.5%
o	572306	19.5%
l	123984	4.2%
u	79866	2.7%
H	72118	2.5%
f	72118	2.5%
a	51868	1.8%
p	51866	1.8%
r	28000	1.0%
m	20252	0.7%
U	7748	0.3%
s	7748	0.3%

sidewalk
Categorical

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	31616
Missing (%)	4.6%
Memory size	5.2 MiB

NoDamage	464978
Damage	187194

Value	Count	Frequency (%)
NoDamage	464978	68.0%
Damage	187194	27.4%
(Missing)	31616	4.6%

Length

Max length	8
Median length	8
Mean length	7.221296659
Min length	3

Overview of Unicode Properties

Unique unicode characters	8
Unique unicode categories (?)	2
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
a	1335960	27.1%
D	652172	13.2%
m	652172	13.2%
g	652172	13.2%
e	652172	13.2%
N	464978	9.4%
o	464978	9.4%
n	63232	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3820686	77.4%
Uppercase Letter	1117150	22.6%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
D	652172	58.4%
N	464978	41.6%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
a	1335960	35.0%
m	652172	17.1%
g	652172	17.1%
e	652172	17.1%
o	464978	12.2%
n	63232	1.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4937836	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
a	1335960	27.1%
D	652172	13.2%
m	652172	13.2%
g	652172	13.2%
e	652172	13.2%
N	464978	9.4%
o	464978	9.4%
n	63232	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4937836	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
a	1335960	27.1%
D	652172	13.2%
m	652172	13.2%
g	652172	13.2%
e	652172	13.2%
N	464978	9.4%
o	464978	9.4%
n	63232	1.3%

user_type
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

TreesCount Staff	296284
Volunteer	217518
NYC Parks Staff	169986

Value	Count	Frequency (%)
TreesCount Staff	296284	43.3%
Volunteer	217518	31.8%
NYC Parks Staff	169986	24.9%

Length

Max length	16
Median length	15
Mean length	13.52465384
Min length	9

Overview of Unicode Properties

Unique unicode characters	19
Unique unicode categories (?)	3
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	1027604	11.1%
t	980072	10.6%
f	932540	10.1%
r	683788	7.4%
	636256	6.9%
a	636256	6.9%
o	513802	5.6%
u	513802	5.6%
n	513802	5.6%
s	466270	5.0%
C	466270	5.0%
S	466270	5.0%
T	296284	3.2%
V	217518	2.4%
l	217518	2.4%
N	169986	1.8%
Y	169986	1.8%
P	169986	1.8%
k	169986	1.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6655440	72.0%
Uppercase Letter	1956300	21.2%
Space Separator	636256	6.9%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
C	466270	23.8%
S	466270	23.8%
T	296284	15.1%
V	217518	11.1%
N	169986	8.7%
Y	169986	8.7%
P	169986	8.7%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	1027604	15.4%
t	980072	14.7%
f	932540	14.0%
r	683788	10.3%
a	636256	9.6%
o	513802	7.7%
u	513802	7.7%
n	513802	7.7%
s	466270	7.0%
l	217518	3.3%
k	169986	2.6%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	636256	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8611740	93.1%
Common	636256	6.9%

Most frequent Latin characters

Value	Count	Frequency (%)
e	1027604	11.9%
t	980072	11.4%
f	932540	10.8%
r	683788	7.9%
a	636256	7.4%
o	513802	6.0%
u	513802	6.0%
n	513802	6.0%
s	466270	5.4%
C	466270	5.4%
S	466270	5.4%
T	296284	3.4%
V	217518	2.5%
l	217518	2.5%
N	169986	2.0%
Y	169986	2.0%
P	169986	2.0%
k	169986	2.0%

Most frequent Common characters

Value	Count	Frequency (%)
	636256	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9247996	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	1027604	11.1%
t	980072	10.6%
f	932540	10.1%
r	683788	7.4%
	636256	6.9%
a	636256	6.9%
o	513802	5.6%
u	513802	5.6%
n	513802	5.6%
s	466270	5.0%
C	466270	5.0%
S	466270	5.0%
T	296284	3.2%
V	217518	2.4%
l	217518	2.4%
N	169986	1.8%
Y	169986	1.8%
P	169986	1.8%
k	169986	1.8%

problems
Categorical

HIGH CARDINALITY
MISSING

Distinct count	232
Unique (%)	< 0.1%
Missing	31664
Missing (%)	4.6%
Memory size	5.2 MiB

None	426280
Stones	95673
BranchLights	29452
Stones,BranchLights	17808
RootOther	11418
Other values (227)	71493

Value	Count	Frequency (%)
None	426280	62.3%
Stones	95673	14.0%
BranchLights	29452	4.3%
Stones,BranchLights	17808	2.6%
RootOther	11418	1.7%
TrunkOther	11143	1.6%
BranchOther	8352	1.2%
Stones,TrunkOther	5183	0.8%
Stones,RootOther	4468	0.7%
WiresRope	4095	0.6%
Stones,BranchOther	3786	0.6%
TrunkOther,BranchOther	2477	0.4%
WiresRope,BranchLights	2308	0.3%
RootOther,TrunkOther	2137	0.3%
MetalGrates	2098	0.3%
Stones,WiresRope,BranchLights	1953	0.3%
RootOther,BranchLights	1918	0.3%
RootOther,TrunkOther,BranchOther	1807	0.3%
TrunkOther,BranchLights	1558	0.2%
Stones,TrunkOther,BranchOther	1539	0.2%
RootOther,BranchOther	1503	0.2%
Stones,WiresRope	1457	0.2%
Stones,RootOther,TrunkOther	1360	0.2%
Stones,TrunkOther,BranchLights	1176	0.2%
Stones,RootOther,BranchLights	901	0.1%
Other values (207)	10274	1.5%
(Missing)	31664	4.6%

Length

Max length	95
Median length	4
Mean length	6.595658303
Min length	3

Overview of Unicode Properties

Unique unicode characters	26
Unique unicode categories (?)	3
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	750342	16.6%
e	687971	15.3%
o	640197	14.2%
N	426280	9.5%
t	328039	7.3%
h	237366	5.3%
r	224795	5.0%
s	220616	4.9%
S	140410	3.1%
a	125867	2.8%
O	87250	1.9%
B	86720	1.9%
c	86720	1.9%
,	82022	1.8%
i	76670	1.7%
L	63396	1.4%
g	63396	1.4%
R	43596	1.0%
k	34015	0.8%
T	33604	0.7%
u	33604	0.7%
W	13274	0.3%
p	13274	0.3%
M	3536	0.1%
l	3536	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3526408	78.2%
Uppercase Letter	901602	20.0%
Other Punctuation	82022	1.8%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	426280	47.3%
S	140410	15.6%
O	87250	9.7%
B	86720	9.6%
L	63396	7.0%
R	43596	4.8%
T	33604	3.7%
W	13274	1.5%
M	3536	0.4%
G	3536	0.4%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	750342	21.3%
e	687971	19.5%
o	640197	18.2%
t	328039	9.3%
h	237366	6.7%
r	224795	6.4%
s	220616	6.3%
a	125867	3.6%
c	86720	2.5%
i	76670	2.2%
g	63396	1.8%
k	34015	1.0%
u	33604	1.0%
p	13274	0.4%
l	3536	0.1%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
,	82022	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4428010	98.2%
Common	82022	1.8%

Most frequent Latin characters

Value	Count	Frequency (%)
n	750342	16.9%
e	687971	15.5%
o	640197	14.5%
N	426280	9.6%
t	328039	7.4%
h	237366	5.4%
r	224795	5.1%
s	220616	5.0%
S	140410	3.2%
a	125867	2.8%
O	87250	2.0%
B	86720	2.0%
c	86720	2.0%
i	76670	1.7%
L	63396	1.4%
g	63396	1.4%
R	43596	1.0%
k	34015	0.8%
T	33604	0.8%
u	33604	0.8%
W	13274	0.3%
p	13274	0.3%
M	3536	0.1%
l	3536	0.1%
G	3536	0.1%

Most frequent Common characters

Value	Count	Frequency (%)
,	82022	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4510032	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	750342	16.6%
e	687971	15.3%
o	640197	14.2%
N	426280	9.5%
t	328039	7.3%
h	237366	5.3%
r	224795	5.0%
s	220616	4.9%
S	140410	3.1%
a	125867	2.8%
O	87250	1.9%
B	86720	1.9%
c	86720	1.9%
,	82022	1.8%
i	76670	1.7%
L	63396	1.4%
g	63396	1.4%
R	43596	1.0%
k	34015	0.8%
T	33604	0.7%
u	33604	0.7%
W	13274	0.3%
p	13274	0.3%
M	3536	0.1%
l	3536	0.1%

root_stone
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	543789
Yes	139999

Frequency Table

Value	Count	Frequency (%)
No	543789	79.5%
Yes	139999	20.5%

root_grate
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	680252
Yes	3536

Frequency Table

Value	Count	Frequency (%)
No	680252	99.5%
Yes	3536	0.5%

root_other
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	653466
Yes	30322

Frequency Table

Value	Count	Frequency (%)
No	653466	95.6%
Yes	30322	4.4%

trunk_wire
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	670514
Yes	13274

Frequency Table

Value	Count	Frequency (%)
No	670514	98.1%
Yes	13274	1.9%

trnk_light
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	682757
Yes	1031

Frequency Table

Value	Count	Frequency (%)
No	682757	99.8%
Yes	1031	0.2%

trnk_other
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	651215
Yes	32573

Frequency Table

Value	Count	Frequency (%)
No	651215	95.2%
Yes	32573	4.8%

brch_light
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	621423
Yes	62365

Frequency Table

Value	Count	Frequency (%)
No	621423	90.9%
Yes	62365	9.1%

brch_shoe
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	683377
Yes	411

Frequency Table

Value	Count	Frequency (%)
No	683377	99.9%
Yes	411	0.1%

brch_other
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

No	659433
Yes	24355

Frequency Table

Value	Count	Frequency (%)
No	659433	96.4%
Yes	24355	3.6%

address
Categorical

HIGH CARDINALITY

Distinct count	408701
Unique (%)	59.8%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

106 CROSS BAY BOULEVARD	262
2 TELEPORT DRIVE	143
2350 FOREST HILL ROAD	140
900 SOUTH AVENUE	90
2750 VETERANS ROAD WEST	84
Other values (408696)	683069

Value	Count	Frequency (%)
106 CROSS BAY BOULEVARD	262	< 0.1%
2 TELEPORT DRIVE	143	< 0.1%
2350 FOREST HILL ROAD	140	< 0.1%
900 SOUTH AVENUE	90	< 0.1%
2750 VETERANS ROAD WEST	84	< 0.1%
79-25 WINCHESTER BOULEVARD	79	< 0.1%
1200 SOUTH AVENUE	74	< 0.1%
69-053 210 STREET	74	< 0.1%
204 EDWARD CURRY AVENUE	67	< 0.1%
164-055 96 STREET	64	< 0.1%
120 CASALS PLACE	63	< 0.1%
3034 GOULDEN AVENUE	61	< 0.1%
28-055 ULMER STREET	59	< 0.1%
79-20 WINCHESTER BOULEVARD	57	< 0.1%
402 HUNTS POINT AVENUE	56	< 0.1%
3671 HUDSON MANOR TERRACE	55	< 0.1%
224 WEST STREET	55	< 0.1%
96 PARKSIDE AVENUE	53	< 0.1%
146-056 SPRINGFIELD BOULEVARD	53	< 0.1%
9000 BAY PARKWAY	51	< 0.1%
610 RIVER AVENUE	50	< 0.1%
2925 VETERANS ROAD WEST	50	< 0.1%
151 MAGUIRE AVENUE	49	< 0.1%
2200 ARTHUR KILL ROAD	49	< 0.1%
73-004 199 STREET	48	< 0.1%
Other values (408676)	681902	99.7%

Length

Max length	40
Median length	18
Mean length	18.02302176
Min length	1

Overview of Unicode Properties

Unique unicode characters	39
Unique unicode categories (?)	5
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
E	1564995	12.7%
	1503773	12.2%
T	847317	6.9%
A	680093	5.5%
R	632291	5.1%
1	625603	5.1%
0	548667	4.5%
S	538560	4.4%
N	506195	4.1%
2	422115	3.4%
U	352144	2.9%
V	324424	2.6%
3	307178	2.5%
4	297043	2.4%
O	290207	2.4%
5	287307	2.3%
6	245067	2.0%
L	239144	1.9%
-	238924	1.9%
7	225537	1.8%
8	221016	1.8%
9	196150	1.6%
D	180971	1.5%
I	166521	1.4%
C	142586	1.2%
Other values (14)	740098	6.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7205359	58.5%
Decimal Number	3375683	27.4%
Space Separator	1503773	12.2%
Dash Punctuation	238924	1.9%
Other Punctuation	187	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	625603	18.5%
0	548667	16.3%
2	422115	12.5%
3	307178	9.1%
4	297043	8.8%
5	287307	8.5%
6	245067	7.3%
7	225537	6.7%
8	221016	6.5%
9	196150	5.8%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	238924	100.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	1503773	100.0%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
E	1564995	21.7%
T	847317	11.8%
A	680093	9.4%
R	632291	8.8%
S	538560	7.5%
N	506195	7.0%
U	352144	4.9%
V	324424	4.5%
O	290207	4.0%
L	239144	3.3%
D	180971	2.5%
I	166521	2.3%
C	142586	2.0%
W	104715	1.5%
H	101813	1.4%
B	97722	1.4%
P	89028	1.2%
M	81849	1.1%
Y	73421	1.0%
G	66483	0.9%
K	59971	0.8%
F	41317	0.6%
J	9595	0.1%
X	7712	0.1%
Q	3335	< 0.1%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
'	187	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7205359	58.5%
Common	5118567	41.5%

Most frequent Common characters

Value	Count	Frequency (%)
	1503773	29.4%
1	625603	12.2%
0	548667	10.7%
2	422115	8.2%
3	307178	6.0%
4	297043	5.8%
5	287307	5.6%
6	245067	4.8%
-	238924	4.7%
7	225537	4.4%
8	221016	4.3%
9	196150	3.8%
'	187	< 0.1%

Most frequent Latin characters

Value	Count	Frequency (%)
E	1564995	21.7%
T	847317	11.8%
A	680093	9.4%
R	632291	8.8%
S	538560	7.5%
N	506195	7.0%
U	352144	4.9%
V	324424	4.5%
O	290207	4.0%
L	239144	3.3%
D	180971	2.5%
I	166521	2.3%
C	142586	2.0%
W	104715	1.5%
H	101813	1.4%
B	97722	1.4%
P	89028	1.2%
M	81849	1.1%
Y	73421	1.0%
G	66483	0.9%
K	59971	0.8%
F	41317	0.6%
J	9595	0.1%
X	7712	0.1%
Q	3335	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12323926	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
E	1564995	12.7%
	1503773	12.2%
T	847317	6.9%
A	680093	5.5%
R	632291	5.1%
1	625603	5.1%
0	548667	4.5%
S	538560	4.4%
N	506195	4.1%
2	422115	3.4%
U	352144	2.9%
V	324424	2.6%
3	307178	2.5%
4	297043	2.4%
O	290207	2.4%
5	287307	2.3%
6	245067	2.0%
L	239144	1.9%
-	238924	1.9%
7	225537	1.8%
8	221016	1.8%
9	196150	1.6%
D	180971	1.5%
I	166521	1.4%
C	142586	1.2%
Other values (14)	740098	6.0%

postcode
Real number (ℝ_≥0)

Distinct count	191
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10916.246044095538
Minimum	83
Maximum	11697
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	83
5-th percentile	10025
Q1	10451
median	11214
Q3	11365
95-th percentile	11432
Maximum	11697
Range	11614
Interquartile range (IQR)	914

Descriptive statistics

Standard deviation	651.5533636
Coefficient of variation (CV)	0.05968657732
Kurtosis	102.1137958
Mean	10916.24604
Median Absolute Deviation (MAD)	203
Skewness	-6.507755595
Sum	7464398050
Variance	424521.7856

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10312	22186	3.2%
10314	16905	2.5%
10306	13030	1.9%
10309	12650	1.8%
11234	11253	1.6%
11385	10937	1.6%
11357	9449	1.4%
11207	8634	1.3%
11434	8274	1.2%
11208	8245	1.2%
11413	7470	1.1%
11365	7428	1.1%
11230	7336	1.1%
10308	7116	1.0%
11375	7059	1.0%
11364	7054	1.0%
11432	6958	1.0%
11358	6928	1.0%
11236	6859	1.0%
10305	6855	1.0%
10469	6710	1.0%
11215	6360	0.9%
11422	6324	0.9%
11209	6201	0.9%
11361	6181	0.9%
Other values (166)	459386	67.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
83	935	0.1%
10001	911	0.1%
10002	2265	0.3%
10003	2025	0.3%
10004	118	< 0.1%
10005	144	< 0.1%
10006	53	< 0.1%
10007	355	0.1%
10009	1924	0.3%
10010	889	0.1%

Value	Count	Frequency (%)
11697	30	< 0.1%
11694	3572	0.5%
11693	1169	0.2%
11692	2013	0.3%
11691	5718	0.8%
11451	12	< 0.1%
11436	2407	0.4%
11435	4595	0.7%
11434	8274	1.2%
11433	3745	0.5%

zip_city
Categorical

HIGH CORRELATION

Distinct count	48
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

Brooklyn	177300
Staten Island	105318
Bronx	85203
New York	64488
Jamaica	26028
Other values (43)	225451

Value	Count	Frequency (%)
Brooklyn	177300	25.9%
Staten Island	105318	15.4%
Bronx	85203	12.5%
New York	64488	9.4%
Jamaica	26028	3.8%
Flushing	23389	3.4%
Ridgewood	10937	1.6%
Fresh Meadows	10441	1.5%
Queens Village	10127	1.5%
Astoria	10007	1.5%
Whitestone	9449	1.4%
Bayside	8679	1.3%
Springfield Gardens	7470	1.1%
Little Neck	7280	1.1%
Forest Hills	7059	1.0%
Oakland Gardens	7054	1.0%
Far Rockaway	6887	1.0%
East Elmhurst	6475	0.9%
Rosedale	6324	0.9%
Woodside	5651	0.8%
South Ozone Park	5494	0.8%
Ozone Park	5456	0.8%
Bellerose	5121	0.7%
Middle Village	4893	0.7%
Saint Albans	4697	0.7%
Other values (23)	62561	9.1%

Length

Max length	19
Median length	8
Mean length	9.315960502
Min length	5

Overview of Unicode Properties

Unique unicode characters	46
Unique unicode categories (?)	3
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
o	662058	10.4%
n	604433	9.5%
a	474555	7.4%
l	446198	7.0%
r	440622	6.9%
e	400969	6.3%
t	309410	4.9%
	305628	4.8%
k	294951	4.6%
s	283899	4.5%
B	280983	4.4%
d	224233	3.5%
y	202476	3.2%
i	182037	2.9%
S	127448	2.0%
I	108806	1.7%
w	103592	1.6%
h	86515	1.4%
x	85203	1.3%
g	73002	1.1%
N	72633	1.1%
Y	64488	1.0%
c	57908	0.9%
u	54158	0.9%
F	49315	0.8%
Other values (21)	374622	5.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5075098	79.7%
Uppercase Letter	989416	15.5%
Space Separator	305628	4.8%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
B	280983	28.4%
S	127448	12.9%
I	108806	11.0%
N	72633	7.3%
Y	64488	6.5%
F	49315	5.0%
R	37000	3.7%
J	29323	3.0%
H	28885	2.9%
P	24074	2.4%
O	22134	2.2%
G	20397	2.1%
M	19367	2.0%
W	17955	1.8%
E	17154	1.7%
A	16717	1.7%
C	15088	1.5%
V	15020	1.5%
L	10759	1.1%
Q	10127	1.0%
K	1743	0.2%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
o	662058	13.0%
n	604433	11.9%
a	474555	9.4%
l	446198	8.8%
r	440622	8.7%
e	400969	7.9%
t	309410	6.1%
k	294951	5.8%
s	283899	5.6%
d	224233	4.4%
y	202476	4.0%
i	182037	3.6%
w	103592	2.0%
h	86515	1.7%
x	85203	1.7%
g	73002	1.4%
c	57908	1.1%
u	54158	1.1%
m	46132	0.9%
p	11503	0.2%
z	10980	0.2%
b	7926	0.2%
f	7470	0.1%
v	4868	0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	305628	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6064514	95.2%
Common	305628	4.8%

Most frequent Latin characters

Value	Count	Frequency (%)
o	662058	10.9%
n	604433	10.0%
a	474555	7.8%
l	446198	7.4%
r	440622	7.3%
e	400969	6.6%
t	309410	5.1%
k	294951	4.9%
s	283899	4.7%
B	280983	4.6%
d	224233	3.7%
y	202476	3.3%
i	182037	3.0%
S	127448	2.1%
I	108806	1.8%
w	103592	1.7%
h	86515	1.4%
x	85203	1.4%
g	73002	1.2%
N	72633	1.2%
Y	64488	1.1%
c	57908	1.0%
u	54158	0.9%
F	49315	0.8%
m	46132	0.8%
Other values (20)	328490	5.4%

Most frequent Common characters

Value	Count	Frequency (%)
	305628	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6370142	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
o	662058	10.4%
n	604433	9.5%
a	474555	7.4%
l	446198	7.0%
r	440622	6.9%
e	400969	6.3%
t	309410	4.9%
	305628	4.8%
k	294951	4.6%
s	283899	4.5%
B	280983	4.4%
d	224233	3.5%
y	202476	3.2%
i	182037	2.9%
S	127448	2.0%
I	108806	1.7%
w	103592	1.6%
h	86515	1.4%
x	85203	1.3%
g	73002	1.1%
N	72633	1.1%
Y	64488	1.0%
c	57908	0.9%
u	54158	0.9%
F	49315	0.8%
Other values (21)	374622	5.9%

community board
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	59
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	343.50540372162135
Minimum	101
Maximum	503
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	101
5-th percentile	108
Q1	302
median	402
Q3	412
95-th percentile	503
Maximum	503
Range	402
Interquartile range (IQR)	110

Descriptive statistics

Standard deviation	115.7406006
Coefficient of variation (CV)	0.3369396794
Kurtosis	-0.5111178327
Mean	343.5054037
Median Absolute Deviation (MAD)	92
Skewness	-0.5610389849
Sum	234884873
Variance	13395.88663

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
503	53934	7.9%
413	37017	5.4%
407	30620	4.5%
411	28071	4.1%
412	26379	3.9%
502	25717	3.8%
501	25667	3.8%
408	20383	3.0%
405	19550	2.9%
318	19319	2.8%
305	16589	2.4%
410	15224	2.2%
315	13758	2.0%
401	13008	1.9%
312	12500	1.8%
414	12412	1.8%
301	12066	1.8%
409	11481	1.7%
210	11180	1.6%
212	11108	1.6%
403	10827	1.6%
310	10598	1.5%
314	10536	1.5%
306	10290	1.5%
406	10258	1.5%
Other values (34)	215296	31.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
101	2397	0.4%
102	5019	0.7%
103	4939	0.7%
104	4704	0.7%
105	2156	0.3%
106	5061	0.7%
107	8814	1.3%
108	9269	1.4%
109	4987	0.7%
110	5962	0.9%

Value	Count	Frequency (%)
503	53934	7.9%
502	25717	3.8%
501	25667	3.8%
414	12412	1.8%
413	37017	5.4%
412	26379	3.9%
411	28071	4.1%
410	15224	2.2%
409	11481	1.7%
408	20383	3.0%

borocode
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.3585000029248833
Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	4
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1667456
Coefficient of variation (CV)	0.3474008037
Kurtosis	-0.5342007856
Mean	3.358500003
Median Absolute Deviation (MAD)	1
Skewness	-0.5046858172
Sum	2296502
Variance	1.361295296

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	250551	36.6%
3	177293	25.9%
5	105318	15.4%
2	85203	12.5%
1	65423	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	65423	9.6%
2	85203	12.5%
3	177293	25.9%
4	250551	36.6%
5	105318	15.4%

Value	Count	Frequency (%)
5	105318	15.4%
4	250551	36.6%
3	177293	25.9%
2	85203	12.5%
1	65423	9.6%

borough
Categorical

HIGH CORRELATION

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

Queens	250551
Brooklyn	177293
Staten Island	105318
Bronx	85203
Manhattan	65423

Value	Count	Frequency (%)
Queens	250551	36.6%
Brooklyn	177293	25.9%
Staten Island	105318	15.4%
Bronx	85203	12.5%
Manhattan	65423	9.6%

Length

Max length	13
Median length	8
Mean length	7.759138797
Min length	5

Overview of Unicode Properties

Unique unicode characters	20
Unique unicode categories (?)	3
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	854529	16.1%
e	606420	11.4%
o	439789	8.3%
a	406905	7.7%
s	355869	6.7%
t	341482	6.4%
l	282611	5.3%
B	262496	4.9%
r	262496	4.9%
Q	250551	4.7%
u	250551	4.7%
k	177293	3.3%
y	177293	3.3%
S	105318	2.0%
	105318	2.0%
I	105318	2.0%
d	105318	2.0%
x	85203	1.6%
M	65423	1.2%
h	65423	1.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4411182	83.1%
Uppercase Letter	789106	14.9%
Space Separator	105318	2.0%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
B	262496	33.3%
Q	250551	31.8%
S	105318	13.3%
I	105318	13.3%
M	65423	8.3%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	854529	19.4%
e	606420	13.7%
o	439789	10.0%
a	406905	9.2%
s	355869	8.1%
t	341482	7.7%
l	282611	6.4%
r	262496	6.0%
u	250551	5.7%
k	177293	4.0%
y	177293	4.0%
d	105318	2.4%
x	85203	1.9%
h	65423	1.5%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	105318	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5200288	98.0%
Common	105318	2.0%

Most frequent Latin characters

Value	Count	Frequency (%)
n	854529	16.4%
e	606420	11.7%
o	439789	8.5%
a	406905	7.8%
s	355869	6.8%
t	341482	6.6%
l	282611	5.4%
B	262496	5.0%
r	262496	5.0%
Q	250551	4.8%
u	250551	4.8%
k	177293	3.4%
y	177293	3.4%
S	105318	2.0%
I	105318	2.0%
d	105318	2.0%
x	85203	1.6%
M	65423	1.3%
h	65423	1.3%

Most frequent Common characters

Value	Count	Frequency (%)
	105318	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5305606	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	854529	16.1%
e	606420	11.4%
o	439789	8.3%
a	406905	7.7%
s	355869	6.7%
t	341482	6.4%
l	282611	5.3%
B	262496	4.9%
r	262496	4.9%
Q	250551	4.7%
u	250551	4.7%
k	177293	3.3%
y	177293	3.3%
S	105318	2.0%
	105318	2.0%
I	105318	2.0%
d	105318	2.0%
x	85203	1.6%
M	65423	1.2%
h	65423	1.2%

cncldist
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	51
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	29.943181219910265
Minimum	1
Maximum	51
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	19
median	30
Q3	43
95-th percentile	51
Maximum	51
Range	50
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.32853127
Coefficient of variation (CV)	0.4785240139
Kurtosis	-1.050565109
Mean	29.94318122
Median Absolute Deviation (MAD)	12
Skewness	-0.1089933201
Sum	20474788
Variance	205.3068082

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
51	51236	7.5%
19	34429	5.0%
50	33035	4.8%
23	30743	4.5%
31	23161	3.4%
49	21047	3.1%
27	20116	2.9%
32	19508	2.9%
24	18993	2.8%
30	18551	2.7%
13	17587	2.6%
46	16913	2.5%
28	15807	2.3%
20	14189	2.1%
29	13946	2.0%
39	13859	2.0%
43	13196	1.9%
42	13117	1.9%
33	12784	1.9%
17	11851	1.7%
48	11786	1.7%
45	11758	1.7%
44	11659	1.7%
22	11537	1.7%
37	10990	1.6%
Other values (26)	211990	31.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5694	0.8%
2	5564	0.8%
3	8631	1.3%
4	8521	1.2%
5	4982	0.7%
6	8050	1.2%
7	6572	1.0%
8	7293	1.1%
9	8213	1.2%
10	6501	1.0%

Value	Count	Frequency (%)
51	51236	7.5%
50	33035	4.8%
49	21047	3.1%
48	11786	1.7%
47	9259	1.4%
46	16913	2.5%
45	11758	1.7%
44	11659	1.7%
43	13196	1.9%
42	13117	1.9%

st_assem
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	65
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50.791583063756605
Minimum	23
Maximum	87
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	23
5-th percentile	24
Q1	33
median	52
Q3	64
95-th percentile	83
Maximum	87
Range	64
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	18.96652002
Coefficient of variation (CV)	0.3734185642
Kurtosis	-1.167528325
Mean	50.79158306
Median Absolute Deviation (MAD)	16
Skewness	0.1590070245
Sum	34730675
Variance	359.7288818

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
62	46002	6.7%
26	27763	4.1%
64	22922	3.4%
63	21883	3.2%
25	21514	3.1%
33	20927	3.1%
61	17669	2.6%
24	17643	2.6%
23	17615	2.6%
29	17572	2.6%
27	14853	2.2%
31	14451	2.1%
28	13789	2.0%
32	13443	2.0%
59	13223	1.9%
82	12887	1.9%
30	11689	1.7%
52	11625	1.7%
60	11365	1.7%
41	10674	1.6%
37	10275	1.5%
40	10257	1.5%
44	10083	1.5%
38	9967	1.5%
50	9671	1.4%
Other values (40)	274026	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
23	17615	2.6%
24	17643	2.6%
25	21514	3.1%
26	27763	4.1%
27	14853	2.2%
28	13789	2.0%
29	17572	2.6%
30	11689	1.7%
31	14451	2.1%
32	13443	2.0%

Value	Count	Frequency (%)
87	7428	1.1%
86	5530	0.8%
85	6543	1.0%
84	8253	1.2%
83	8808	1.3%
82	12887	1.9%
81	8537	1.2%
80	9314	1.4%
79	7083	1.0%
78	5182	0.8%

st_senate
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	26
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.615781499529096
Minimum	10
Maximum	36
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	10
5-th percentile	10
Q1	14
median	21
Q3	25
95-th percentile	34
Maximum	36
Range	26
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.390843831
Coefficient of variation (CV)	0.3585041795
Kurtosis	-0.9483978839
Mean	20.6157815
Median Absolute Deviation (MAD)	6
Skewness	0.2993718667
Sum	14096824
Variance	54.62457253

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
24	87241	12.8%
11	67705	9.9%
15	44624	6.5%
14	38351	5.6%
10	35044	5.1%
34	31066	4.5%
19	29083	4.3%
22	27179	4.0%
23	25401	3.7%
16	24146	3.5%
25	23499	3.4%
17	22225	3.3%
12	21847	3.2%
21	20730	3.0%
18	20603	3.0%
13	18827	2.8%
20	16848	2.5%
26	16456	2.4%
32	15915	2.3%
36	14544	2.1%
33	14462	2.1%
29	14285	2.1%
30	13929	2.0%
27	13685	2.0%
28	13195	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	35044	5.1%
11	67705	9.9%
12	21847	3.2%
13	18827	2.8%
14	38351	5.6%
15	44624	6.5%
16	24146	3.5%
17	22225	3.3%
18	20603	3.0%
19	29083	4.3%

Value	Count	Frequency (%)
36	14544	2.1%
34	31066	4.5%
33	14462	2.1%
32	15915	2.3%
31	12898	1.9%
30	13929	2.0%
29	14285	2.1%
28	13195	1.9%
27	13685	2.0%
26	16456	2.4%

nta
Categorical

HIGH CARDINALITY

Distinct count	188
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

SI01	12969
SI54	10734
QN46	9780
BK82	9607
SI32	9251
Other values (183)	631447

Value	Count	Frequency (%)
SI01	12969	1.9%
SI54	10734	1.6%
QN46	9780	1.4%
BK82	9607	1.4%
SI32	9251	1.4%
SI05	8446	1.2%
SI11	8216	1.2%
QN17	7701	1.1%
QN49	7620	1.1%
BK45	7449	1.1%
QN55	7321	1.1%
QN45	7302	1.1%
QN08	7239	1.1%
QN51	7133	1.0%
BK31	7026	1.0%
SI48	6999	1.0%
QN28	6863	1.0%
QN34	6856	1.0%
QN44	6814	1.0%
QN20	6481	0.9%
BK61	6411	0.9%
BK37	6314	0.9%
QN43	6246	0.9%
BK42	6116	0.9%
QN42	6059	0.9%
Other values (163)	490835	71.8%

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Overview of Unicode Properties

Unique unicode characters	18
Unique unicode categories (?)	2
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
N	316193	11.6%
B	262277	9.6%
Q	250524	9.2%
3	187685	6.9%
2	182588	6.7%
K	177320	6.5%
4	174978	6.4%
1	167614	6.1%
5	160168	5.9%
0	138820	5.1%
S	105318	3.9%
I	105318	3.9%
7	104302	3.8%
6	97530	3.6%
8	97514	3.6%
X	84957	3.1%
M	65669	2.4%
9	56377	2.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1367576	50.0%
Decimal Number	1367576	50.0%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	316193	23.1%
B	262277	19.2%
Q	250524	18.3%
K	177320	13.0%
S	105318	7.7%
I	105318	7.7%
X	84957	6.2%
M	65669	4.8%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
3	187685	13.7%
2	182588	13.4%
4	174978	12.8%
1	167614	12.3%
5	160168	11.7%
0	138820	10.2%
7	104302	7.6%
6	97530	7.1%
8	97514	7.1%
9	56377	4.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1367576	50.0%
Common	1367576	50.0%

Most frequent Latin characters

Value	Count	Frequency (%)
N	316193	23.1%
B	262277	19.2%
Q	250524	18.3%
K	177320	13.0%
S	105318	7.7%
I	105318	7.7%
X	84957	6.2%
M	65669	4.8%

Most frequent Common characters

Value	Count	Frequency (%)
3	187685	13.7%
2	182588	13.4%
4	174978	12.8%
1	167614	12.3%
5	160168	11.7%
0	138820	10.2%
7	104302	7.6%
6	97530	7.1%
8	97514	7.1%
9	56377	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2735152	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
N	316193	11.6%
B	262277	9.6%
Q	250524	9.2%
3	187685	6.9%
2	182588	6.7%
K	177320	6.5%
4	174978	6.4%
1	167614	6.1%
5	160168	5.9%
0	138820	5.1%
S	105318	3.9%
I	105318	3.9%
7	104302	3.8%
6	97530	3.6%
8	97514	3.6%
X	84957	3.1%
M	65669	2.4%
9	56377	2.1%

nta_name
Categorical

HIGH CARDINALITY

Distinct count	188
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

Annadale-Huguenot-Prince's Bay-Eltingville	12969
Great Kills	10734
Bayside-Bayside Hills	9780
East New York	9607
Rossville-Woodrow	9251
Other values (183)	631447

Value	Count	Frequency (%)
Annadale-Huguenot-Prince's Bay-Eltingville	12969	1.9%
Great Kills	10734	1.6%
Bayside-Bayside Hills	9780	1.4%
East New York	9607	1.4%
Rossville-Woodrow	9251	1.4%
New Springville-Bloomfield-Travis	8446	1.2%
Charleston-Richmond Valley-Tottenville	8216	1.2%
Forest Hills	7701	1.1%
Whitestone	7620	1.1%
Georgetown-Marine Park-Bergen Beach-Mill Basin	7449	1.1%
South Ozone Park	7321	1.1%
Douglas Manor-Douglaston-Little Neck	7302	1.1%
St. Albans	7239	1.1%
Murray Hill	7133	1.0%
Bay Ridge	7026	1.0%
Arden Heights	6999	1.0%
Jackson Heights	6863	1.0%
Queens Village	6856	1.0%
Glen Oaks-Floral Park-New Hyde Park	6814	1.0%
Ridgewood	6481	0.9%
Crown Heights North	6411	0.9%
Park Slope-Gowanus	6314	0.9%
Bellerose	6246	0.9%
Flatbush	6116	0.9%
Oakland Gardens	6059	0.9%
Other values (163)	490835	71.8%

Length

Max length	56
Median length	16
Mean length	19.83679737
Min length	6

Overview of Unicode Properties

Unique unicode characters	55
Unique unicode categories (?)	7
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
e	1215359	9.0%
a	963637	7.1%
l	880073	6.5%
o	853763	6.3%
	808646	6.0%
r	804239	5.9%
i	767966	5.7%
n	738160	5.4%
t	732792	5.4%
s	708887	5.2%
-	459153	3.4%
d	403036	3.0%
h	381358	2.8%
g	301441	2.2%
u	274562	2.0%
H	254261	1.9%
B	226733	1.7%
w	213588	1.6%
k	196615	1.4%
y	184019	1.4%
c	183613	1.4%
S	160874	1.2%
P	154900	1.1%
m	133229	1.0%
C	127859	0.9%
Other values (30)	1435401	10.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10289513	75.9%
Uppercase Letter	1967877	14.5%
Space Separator	808646	6.0%
Dash Punctuation	459153	3.4%
Other Punctuation	32993	0.2%
Open Punctuation	2991	< 0.1%
Close Punctuation	2991	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
H	254261	12.9%
B	226733	11.5%
S	160874	8.2%
P	154900	7.9%
C	127859	6.5%
M	108390	5.5%
G	96399	4.9%
E	95949	4.9%
N	95605	4.9%
W	94221	4.8%
R	80478	4.1%
F	70744	3.6%
O	54561	2.8%
A	54203	2.8%
V	47787	2.4%
T	47070	2.4%
L	44526	2.3%
D	36147	1.8%
K	25088	1.3%
U	24173	1.2%
J	22724	1.2%
Y	17855	0.9%
I	16088	0.8%
Q	11242	0.6%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	1215359	11.8%
a	963637	9.4%
l	880073	8.6%
o	853763	8.3%
r	804239	7.8%
i	767966	7.5%
n	738160	7.2%
t	732792	7.1%
s	708887	6.9%
d	403036	3.9%
h	381358	3.7%
g	301441	2.9%
u	274562	2.7%
w	213588	2.1%
k	196615	1.9%
y	184019	1.8%
c	183613	1.8%
m	133229	1.3%
v	124915	1.2%
p	93509	0.9%
b	70019	0.7%
f	33616	0.3%
z	14916	0.1%
q	8196	0.1%
x	8005	0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	808646	100.0%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	459153	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
'	16745	50.8%
.	16248	49.2%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	2991	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	2991	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12257390	90.4%
Common	1306774	9.6%

Most frequent Latin characters

Value	Count	Frequency (%)
e	1215359	9.9%
a	963637	7.9%
l	880073	7.2%
o	853763	7.0%
r	804239	6.6%
i	767966	6.3%
n	738160	6.0%
t	732792	6.0%
s	708887	5.8%
d	403036	3.3%
h	381358	3.1%
g	301441	2.5%
u	274562	2.2%
H	254261	2.1%
B	226733	1.8%
w	213588	1.7%
k	196615	1.6%
y	184019	1.5%
c	183613	1.5%
S	160874	1.3%
P	154900	1.3%
m	133229	1.1%
C	127859	1.0%
v	124915	1.0%
M	108390	0.9%
Other values (24)	1163121	9.5%

Most frequent Common characters

Value	Count	Frequency (%)
	808646	61.9%
-	459153	35.1%
'	16745	1.3%
.	16248	1.2%
(	2991	0.2%
)	2991	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13564164	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
e	1215359	9.0%
a	963637	7.1%
l	880073	6.5%
o	853763	6.3%
	808646	6.0%
r	804239	5.9%
i	767966	5.7%
n	738160	5.4%
t	732792	5.4%
s	708887	5.2%
-	459153	3.4%
d	403036	3.0%
h	381358	2.8%
g	301441	2.2%
u	274562	2.0%
H	254261	1.9%
B	226733	1.7%
w	213588	1.6%
k	196615	1.4%
y	184019	1.4%
c	183613	1.4%
S	160874	1.2%
P	154900	1.1%
m	133229	1.0%
C	127859	0.9%
Other values (30)	1435401	10.6%

boro_ct
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	2152
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3404914.118364171
Minimum	1000201
Maximum	5032300
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	1000201
5-th percentile	1015700
Q1	3011700
median	4008100
Q3	4103202
95-th percentile	5019800
Maximum	5032300
Range	4032099
Interquartile range (IQR)	1091502

Descriptive statistics

Standard deviation	1175863.419
Coefficient of variation (CV)	0.3453430477
Kurtosis	-0.5389642631
Mean	3404914.118
Median Absolute Deviation (MAD)	964100
Skewness	-0.5502694254
Sum	2.328239415e+12
Variance	1.382654779e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5020801	3776	0.6%
5017600	3245	0.5%
5020803	2749	0.4%
5020804	2723	0.4%
5019800	2620	0.4%
5022600	2452	0.4%
5017005	2402	0.4%
4089200	2399	0.4%
5024401	2392	0.3%
5017010	2269	0.3%
4066400	2102	0.3%
4157101	2098	0.3%
5017008	2096	0.3%
5013800	2031	0.3%
4157901	2021	0.3%
5017009	1997	0.3%
5015601	1941	0.3%
5024402	1901	0.3%
5015602	1847	0.3%
4148300	1806	0.3%
5014604	1796	0.3%
2009300	1742	0.3%
4157902	1707	0.2%
5029103	1636	0.2%
4127700	1604	0.2%
Other values (2127)	628436	91.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000201	70	< 0.1%
1000202	217	< 0.1%
1000600	187	< 0.1%
1000700	144	< 0.1%
1000800	288	< 0.1%
1000900	83	< 0.1%
1001001	24	< 0.1%
1001002	56	< 0.1%
1001200	111	< 0.1%
1001300	94	< 0.1%

Value	Count	Frequency (%)
5032300	114	< 0.1%
5031902	511	0.1%
5031901	393	0.1%
5030302	769	0.1%
5030301	572	0.1%
5029104	1294	0.2%
5029103	1636	0.2%
5029102	752	0.1%
5027900	416	0.1%
5027706	529	0.1%

state
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.2 MiB

New York	683788

Value	Count	Frequency (%)
New York	683788	100.0%

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Overview of Unicode Properties

Unique unicode characters	8
Unique unicode categories (?)	3
Unique unicode scripts (?)	2
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
N	683788	12.5%
e	683788	12.5%
w	683788	12.5%
	683788	12.5%
Y	683788	12.5%
o	683788	12.5%
r	683788	12.5%
k	683788	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3418940	62.5%
Uppercase Letter	1367576	25.0%
Space Separator	683788	12.5%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	683788	50.0%
Y	683788	50.0%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	683788	20.0%
w	683788	20.0%
o	683788	20.0%
r	683788	20.0%
k	683788	20.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	683788	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4786516	87.5%
Common	683788	12.5%

Most frequent Latin characters

Value	Count	Frequency (%)
N	683788	14.3%
e	683788	14.3%
w	683788	14.3%
Y	683788	14.3%
o	683788	14.3%
r	683788	14.3%
k	683788	14.3%

Most frequent Common characters

Value	Count	Frequency (%)
	683788	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5470304	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
N	683788	12.5%
e	683788	12.5%
w	683788	12.5%
	683788	12.5%
Y	683788	12.5%
o	683788	12.5%
r	683788	12.5%
k	683788	12.5%

latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	676080
Unique (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.701261475468044
Minimum	40.49846614
Maximum	40.91291831
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	40.49846614
5-th percentile	40.54844736
Q1	40.6319285
median	40.70061174
Q3	40.76222798
95-th percentile	40.85640711
Maximum	40.91291831
Range	0.41445217
Interquartile range (IQR)	0.130299485

Descriptive statistics

Standard deviation	0.09031135514
Coefficient of variation (CV)	0.002218883442
Kurtosis	-0.6338341145
Mean	40.70126148
Median Absolute Deviation (MAD)	0.0650372
Skewness	0.06273807884
Sum	27831034.18
Variance	0.008156140868

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
40.66035938	35	< 0.1%
40.61097709	28	< 0.1%
40.689461	17	< 0.1%
40.61596593	17	< 0.1%
40.77849693	11	< 0.1%
40.66036234	9	< 0.1%
40.8830341	9	< 0.1%
40.85571674	8	< 0.1%
40.7715108	8	< 0.1%
40.72263791	7	< 0.1%
40.63264469	7	< 0.1%
40.78750377	7	< 0.1%
40.63609587	6	< 0.1%
40.63607766	6	< 0.1%
40.86765819	6	< 0.1%
40.68993404	6	< 0.1%
40.71819678	5	< 0.1%
40.72858665	5	< 0.1%
40.85119153	5	< 0.1%
40.69312446	5	< 0.1%
40.69334968	5	< 0.1%
40.69312771	5	< 0.1%
40.76254679	5	< 0.1%
40.69338254	4	< 0.1%
40.62272682	4	< 0.1%
Other values (676055)	683558	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.49846614	1	< 0.1%
40.49847126	1	< 0.1%
40.49850958	1	< 0.1%
40.49854295	1	< 0.1%
40.4985987	1	< 0.1%
40.49874956	1	< 0.1%
40.49879352	1	< 0.1%
40.49881226	1	< 0.1%
40.49881678	1	< 0.1%
40.49887148	1	< 0.1%

Value	Count	Frequency (%)
40.91291831	1	< 0.1%
40.91280676	1	< 0.1%
40.91271785	1	< 0.1%
40.91261439	1	< 0.1%
40.91260541	1	< 0.1%
40.9124346	1	< 0.1%
40.91236829	1	< 0.1%
40.91220869	1	< 0.1%
40.91217396	1	< 0.1%
40.91215184	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct count	677101
Unique (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-73.92405951203185
Minimum	-74.2549647
Maximum	-73.70048817
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	-74.2549647
5-th percentile	-74.16993065
Q1	-73.98050019
median	-73.91291141
Q3	-73.83491039
95-th percentile	-73.74446944
Maximum	-73.70048817
Range	0.55447653
Interquartile range (IQR)	0.1455897975

Descriptive statistics

Standard deviation	0.123583459
Coefficient of variation (CV)	-0.001671762344
Kurtosis	-0.1187960159
Mean	-73.92405951
Median Absolute Deviation (MAD)	0.071501375
Skewness	-0.6120792448
Sum	-50548384.81
Variance	0.01527287133

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-73.76103529	35	< 0.1%
-74.15686098	29	< 0.1%
-73.95680062	17	< 0.1%
-73.75274984	17	< 0.1%
-73.79764749	11	< 0.1%
-73.76106931	9	< 0.1%
-73.90045375	9	< 0.1%
-73.91441448	8	< 0.1%
-73.91666671	8	< 0.1%
-73.97329243	7	< 0.1%
-73.85143651	7	< 0.1%
-73.90317884	7	< 0.1%
-73.7845023	7	< 0.1%
-73.79683214	6	< 0.1%
-74.02078026	6	< 0.1%
-74.02080475	6	< 0.1%
-74.01497211	5	< 0.1%
-73.78159893	5	< 0.1%
-73.98628456	5	< 0.1%
-73.98342716	5	< 0.1%
-73.81866391	5	< 0.1%
-73.98516008	5	< 0.1%
-73.89547028	5	< 0.1%
-73.82180059	4	< 0.1%
-73.98615224	4	< 0.1%
Other values (677076)	683556	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.2549647	1	< 0.1%
-74.25489452	1	< 0.1%
-74.25487627	1	< 0.1%
-74.25485662	1	< 0.1%
-74.25483416	1	< 0.1%
-74.25479222	1	< 0.1%
-74.25477504	1	< 0.1%
-74.2547486	1	< 0.1%
-74.25472217	1	< 0.1%
-74.25469573	1	< 0.1%

Value	Count	Frequency (%)
-73.70048817	1	< 0.1%
-73.70059248	1	< 0.1%
-73.70059368	1	< 0.1%
-73.70059651	1	< 0.1%
-73.70060124	1	< 0.1%
-73.7006054	1	< 0.1%
-73.70060622	1	< 0.1%
-73.70061034	1	< 0.1%
-73.70062065	1	< 0.1%
-73.70064005	1	< 0.1%

x_sp
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	681630
Unique (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1005279.8605396459
Minimum	913349.2661
Maximum	1067247.624
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	913349.2661
5-th percentile	937034.4028
Q1	989657.8414
median	1008386.228
Q3	1029991.278
95-th percentile	1055117.133
Maximum	1067247.624
Range	153898.3579
Interquartile range (IQR)	40333.43662

Descriptive statistics

Standard deviation	34285.05448
Coefficient of variation (CV)	0.03410498491
Kurtosis	-0.1137942786
Mean	1005279.861
Median Absolute Deviation (MAD)	19812.1789
Skewness	-0.6143566834
Sum	6.873983053e+11
Variance	1175464961

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1050549.648	35	< 0.1%
940697.4014	28	< 0.1%
1052818.477	17	< 0.1%
996243.4593	17	< 0.1%
1040292.358	11	< 0.1%
1050540.207	9	< 0.1%
1011776.478	9	< 0.1%
1014131.162	9	< 0.1%
1007955.765	8	< 0.1%
1007302.748	8	< 0.1%
991662.9779	7	< 0.1%
1043924.891	7	< 0.1%
1025429.8	7	< 0.1%
978475.7097	6	< 0.1%
978482.5102	6	< 0.1%
1011029.129	6	< 0.1%
1040593.009	6	< 0.1%
980099.654	5	< 0.1%
988845.8038	5	< 0.1%
988365.2352	5	< 0.1%
988053.4195	5	< 0.1%
1013221.651	5	< 0.1%
1044751.552	5	< 0.1%
988734.992	4	< 0.1%
1010695.965	4	< 0.1%
Other values (681605)	683554	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
913349.2661	1	< 0.1%
913368.6477	1	< 0.1%
913373.6867	1	< 0.1%
913379.1135	1	< 0.1%
913385.3156	1	< 0.1%
913396.8953	1	< 0.1%
913401.6387	1	< 0.1%
913408.9363	1	< 0.1%
913416.2338	1	< 0.1%
913423.5311	1	< 0.1%

Value	Count	Frequency (%)
1067247.624	1	< 0.1%
1067220.126	1	< 0.1%
1067219.309	1	< 0.1%
1067218.901	1	< 0.1%
1067217.945	1	< 0.1%
1067216.745	1	< 0.1%
1067215.32	1	< 0.1%
1067214.942	1	< 0.1%
1067212.348	1	< 0.1%
1067206.751	1	< 0.1%

y_sp
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	682632
Unique (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	194798.42462483808
Minimum	120973.7922
Maximum	271894.0921
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	120973.7922
5-th percentile	139145.449
Q1	169515.1537
median	194560.2525
Q3	217019.572
95-th percentile	251311.1615
Maximum	271894.0921
Range	150920.2999
Interquartile range (IQR)	47504.41825

Descriptive statistics

Standard deviation	32902.06111
Coefficient of variation (CV)	0.168903117
Kurtosis	-0.6353082377
Mean	194798.4246
Median Absolute Deviation (MAD)	23708.38335
Skewness	0.0627524678
Sum	1.332008252e+11
Variance	1082545626

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
179953.5509	35	< 0.1%
161910.8114	28	< 0.1%
190562.4395	17	< 0.1%
163692.3397	17	< 0.1%
222968.9875	11	< 0.1%
261006.6421	9	< 0.1%
179954.6024	9	< 0.1%
220370.5573	8	< 0.1%
251049.181	8	< 0.1%
226259.1588	7	< 0.1%
202587.9351	7	< 0.1%
169767.0276	7	< 0.1%
190703.3536	6	< 0.1%
171023.9375	6	< 0.1%
255403.7468	6	< 0.1%
171017.3043	6	< 0.1%
191801.8573	5	< 0.1%
156188.6211	5	< 0.1%
204737.6122	5	< 0.1%
200627.8905	5	< 0.1%
191882.7784	5	< 0.1%
191800.81	5	< 0.1%
217168.5132	5	< 0.1%
200935.3311	5	< 0.1%
192345.0868	4	< 0.1%
Other values (682607)	683557	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
120973.7922	1	< 0.1%
120974.9307	1	< 0.1%
120989.6301	1	< 0.1%
121001.0648	1	< 0.1%
121021.3909	1	< 0.1%
121077.124	1	< 0.1%
121093.1548	1	< 0.1%
121098.6109	1	< 0.1%
121100.9996	1	< 0.1%
121122.1262	1	< 0.1%

Value	Count	Frequency (%)
271894.0921	1	< 0.1%
271853.4435	1	< 0.1%
271821.042	1	< 0.1%
271783.3394	1	< 0.1%
271780.3538	1	< 0.1%
271718.4015	1	< 0.1%
271694.1909	1	< 0.1%
271635.8193	1	< 0.1%
271623.217	1	< 0.1%
271615.2311	1	< 0.1%

council district
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	51
Unique (%)	< 0.1%
Missing	6519
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%

Mean	30.02733035175093
Minimum	1.0
Maximum	51.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	19
median	30
Q3	43
95-th percentile	51
Maximum	51
Range	50
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.30171652
Coefficient of variation (CV)	0.4762899783
Kurtosis	-1.046661632
Mean	30.02733035
Median Absolute Deviation (MAD)	12
Skewness	-0.1146616275
Sum	20336580
Variance	204.5390955

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
51	50865	7.4%
19	33626	4.9%
50	32948	4.8%
23	30411	4.4%
31	22763	3.3%
49	20863	3.1%
27	20061	2.9%
32	19687	2.9%
24	18620	2.7%
30	18307	2.7%
13	17433	2.5%
46	16863	2.5%
28	15635	2.3%
20	14128	2.1%
39	13837	2.0%
29	13789	2.0%
42	13083	1.9%
43	13054	1.9%
33	12740	1.9%
17	11825	1.7%
48	11802	1.7%
45	11717	1.7%
44	11648	1.7%
22	11640	1.7%
37	10995	1.6%
Other values (26)	208929	30.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5404	0.8%
2	5537	0.8%
3	8506	1.2%
4	8649	1.3%
5	4931	0.7%
6	6947	1.0%
7	6519	1.0%
8	7343	1.1%
9	7994	1.2%
10	6137	0.9%

Value	Count	Frequency (%)
51	50865	7.4%
50	32948	4.8%
49	20863	3.1%
48	11802	1.7%
47	9200	1.3%
46	16863	2.5%
45	11717	1.7%
44	11648	1.7%
43	13054	1.9%
42	13083	1.9%

census tract
Real number (ℝ_≥0)

Distinct count	1315
Unique (%)	0.2%
Missing	6519
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%

Mean	11957.368422296015
Minimum	1.0
Maximum	157903.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	1
5-th percentile	50
Q1	202
median	516
Q3	1417
95-th percentile	84601
Maximum	157903
Range	157902
Interquartile range (IQR)	1215

Descriptive statistics

Standard deviation	30745.73981
Coefficient of variation (CV)	2.571279794
Kurtosis	10.97663521
Mean	11957.36842
Median Absolute Deviation (MAD)	385
Skewness	3.349170094
Sum	8098354954
Variance	945300516.5

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
20801	3615	0.5%
176	3613	0.5%
198	3407	0.5%
138	2946	0.4%
226	2802	0.4%
20803	2740	0.4%
20804	2734	0.4%
251	2592	0.4%
892	2578	0.4%
134	2517	0.4%
122	2412	0.4%
17010	2391	0.3%
24401	2385	0.3%
17005	2336	0.3%
70	2278	0.3%
151	2231	0.3%
17008	2111	0.3%
157101	2103	0.3%
664	2100	0.3%
15601	2064	0.3%
157901	2040	0.3%
17009	2012	0.3%
15602	1927	0.3%
93	1916	0.3%
24402	1903	0.3%
Other values (1290)	615516	90.0%
(Missing)	6519	1.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	809	0.1%
2	731	0.1%
3	271	< 0.1%
4	680	0.1%
6	700	0.1%
7	1658	0.2%
8	1450	0.2%
9	610	0.1%
10	159	< 0.1%
11	703	0.1%

Value	Count	Frequency (%)
157903	1378	0.2%
157902	1695	0.2%
157901	2040	0.3%
157102	423	0.1%
157101	2103	0.3%
155102	1583	0.2%
152902	1057	0.2%
152901	806	0.1%
150702	1056	0.2%
150701	1388	0.2%

bin
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	378888
Unique (%)	56.2%
Missing	9559
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%

Mean	3495439.0063153617
Minimum	1000000.0
Maximum	5515124.0
Zeros	0
Zeros (%)	0.0%
Memory size	5.2 MiB

Quantile statistics

Minimum	1000000
5-th percentile	1055120.4
Q1	3031991
median	4020352
Q3	4263123
95-th percentile	5086977
Maximum	5515124
Range	4515124
Interquartile range (IQR)	1231132

Descriptive statistics

Standard deviation	1193274.96
Coefficient of variation (CV)	0.34138057
Kurtosis	-0.5429353008
Mean	3495439.006
Median Absolute Deviation (MAD)	885878
Skewness	-0.6010568435
Sum	2.356726346e+12
Variance	1.423905131e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4000000	561	0.1%
3000000	486	0.1%
2000000	401	0.1%
5000000	342	0.1%
4315089	262	< 0.1%
1000000	260	< 0.1%
5146614	143	< 0.1%
1067973	100	< 0.1%
5113281	90	< 0.1%
1066406	86	< 0.1%
5149741	84	< 0.1%
4438348	79	< 0.1%
4462897	74	< 0.1%
5151612	74	< 0.1%
4444310	74	< 0.1%
4296078	64	< 0.1%
4286097	61	< 0.1%
4539763	57	< 0.1%
1012266	57	< 0.1%
2114610	56	< 0.1%
2117759	55	< 0.1%
2085874	55	< 0.1%
3347226	53	< 0.1%
3340691	51	< 0.1%
5150129	50	< 0.1%
Other values (378863)	670554	98.1%
(Missing)	9559	1.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000000	260	< 0.1%
1000005	8	< 0.1%
1000006	10	< 0.1%
1000012	1	< 0.1%
1000013	2	< 0.1%
1000014	1	< 0.1%
1000018	14	< 0.1%
1000019	1	< 0.1%
1000020	8	< 0.1%
1000021	8	< 0.1%

Value	Count	Frequency (%)
5515124	3	< 0.1%
5513451	1	< 0.1%
5169169	5	< 0.1%
5169168	7	< 0.1%
5169166	1	< 0.1%
5169161	1	< 0.1%
5169153	2	< 0.1%
5169142	2	< 0.1%
5169093	4	< 0.1%
5169070	1	< 0.1%

bbl
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	366635
Unique (%)	54.4%
Missing	9559
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%

Mean	3413413626.228289
Minimum	0.0
Maximum	5080500094.0
Zeros	20
Zeros (%)	< 0.1%
Memory size	5.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1014673024
Q1	3011240055
median	4008560127
Q3	4105700010
95-th percentile	5056060065
Maximum	5080500094
Range	5080500094
Interquartile range (IQR)	1094459955

Descriptive statistics

Standard deviation	1174892044
Coefficient of variation (CV)	0.3441985569
Kurtosis	-0.522131309
Mean	3413413626
Median Absolute Deviation (MAD)	962350119
Skewness	-0.5327777886
Sum	2.301422456e+15
Variance	1.380371315e+18

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2051410120	456	0.1%
4153750020	262	< 0.1%
1009720001	215	< 0.1%
2049050001	166	< 0.1%
1009780001	147	< 0.1%
3044520020	147	< 0.1%
5021650160	143	< 0.1%
3045860300	134	< 0.1%
4124950002	132	< 0.1%
1006800001	120	< 0.1%
4076330001	120	< 0.1%
2039437501	118	< 0.1%
3083290225	114	< 0.1%
4079140002	113	< 0.1%
3005380001	112	< 0.1%
2039387501	111	< 0.1%
4067920030	109	< 0.1%
2051350051	106	< 0.1%
4079290002	103	< 0.1%
3011170001	96	< 0.1%
3044520200	95	< 0.1%
4071170006	92	< 0.1%
5017250085	90	< 0.1%
4085150002	89	< 0.1%
4065400003	89	< 0.1%
Other values (366610)	670750	98.1%
(Missing)	9559	1.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	20	< 0.1%
1000047501	8	< 0.1%
1000057501	10	< 0.1%
1000070031	1	< 0.1%
1000070037	2	< 0.1%
1000070038	1	< 0.1%
1000077501	4	< 0.1%
1000087501	9	< 0.1%
1000090001	14	< 0.1%
1000090007	1	< 0.1%

Value	Count	Frequency (%)
5080500094	2	< 0.1%
5080500092	2	< 0.1%
5080500086	2	< 0.1%
5080500083	2	< 0.1%
5080500078	3	< 0.1%
5080500076	2	< 0.1%
5080500068	3	< 0.1%
5080500060	3	< 0.1%
5080500058	1	< 0.1%
5080500053	3	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	tree_id	block_id	created_at	tree_dbh	curb_loc	status	health	spc_latin	spc_common	steward	guards	sidewalk	user_type	problems	root_stone	root_grate	root_other	trunk_wire	trnk_light	trnk_other	brch_light	brch_shoe	brch_other	address	postcode	zip_city	community board	borocode	borough	cncldist	st_assem	st_senate	nta	nta_name	boro_ct	state	latitude	longitude	x_sp	y_sp	council district	census tract	bin	bbl
0	180683	348711	08/27/2015	3	OnCurb	Alive	Fair	Acer rubrum	red maple	None	None	NoDamage	TreesCount Staff	None	No	No	No	No	No	No	No	No	No	108-005 70 AVENUE	11375	Forest Hills	406	4	Queens	29	28	16	QN17	Forest Hills	4073900	New York	40.723092	-73.844215	1.027431e+06	202756.7687	29.0	739.0	4052307.0	4.022210e+09
1	200540	315986	09/03/2015	21	OnCurb	Alive	Fair	Quercus palustris	pin oak	None	None	Damage	TreesCount Staff	Stones	Yes	No	No	No	No	No	No	No	No	147-074 7 AVENUE	11357	Whitestone	407	4	Queens	19	27	11	QN49	Whitestone	4097300	New York	40.794111	-73.818679	1.034456e+06	228644.8374	19.0	973.0	4101931.0	4.044750e+09
2	204026	218365	09/05/2015	3	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	1or2	None	Damage	Volunteer	None	No	No	No	No	No	No	No	No	No	390 MORGAN AVENUE	11211	Brooklyn	301	3	Brooklyn	34	50	18	BK90	East Williamsburg	3044900	New York	40.717581	-73.936608	1.001823e+06	200716.8913	34.0	449.0	3338310.0	3.028870e+09
3	204337	217969	09/05/2015	10	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	None	None	Damage	Volunteer	Stones	Yes	No	No	No	No	No	No	No	No	1027 GRAND STREET	11211	Brooklyn	301	3	Brooklyn	34	53	18	BK90	East Williamsburg	3044900	New York	40.713537	-73.934456	1.002420e+06	199244.2531	34.0	449.0	3338342.0	3.029250e+09
4	189565	223043	08/30/2015	21	OnCurb	Alive	Good	Tilia americana	American linden	None	None	Damage	Volunteer	Stones	Yes	No	No	No	No	No	No	No	No	603 6 STREET	11215	Brooklyn	306	3	Brooklyn	39	44	21	BK37	Park Slope-Gowanus	3016500	New York	40.666778	-73.975979	9.909138e+05	182202.4260	39.0	165.0	3025654.0	3.010850e+09
5	190422	106099	08/30/2015	11	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	1or2	Helpful	NoDamage	Volunteer	None	No	No	No	No	No	No	No	No	No	8 COLUMBUS AVENUE	10023	New York	107	1	Manhattan	3	67	27	MN14	Lincoln Square	1014500	New York	40.770046	-73.984950	9.884187e+05	219825.5227	3.0	145.0	1076229.0	1.011310e+09
6	190426	106099	08/30/2015	11	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	1or2	Helpful	NoDamage	Volunteer	None	No	No	No	No	No	No	No	No	No	120 WEST 60 STREET	10023	New York	107	1	Manhattan	3	67	27	MN14	Lincoln Square	1014500	New York	40.770210	-73.985338	9.883112e+05	219885.2785	3.0	145.0	1076229.0	1.011310e+09
7	208649	103940	09/07/2015	9	OnCurb	Alive	Good	Tilia americana	American linden	None	None	NoDamage	Volunteer	MetalGrates	No	Yes	No	No	No	No	No	No	No	311 WEST 50 STREET	10019	New York	104	1	Manhattan	3	75	27	MN15	Clinton	1012700	New York	40.762724	-73.987297	9.877691e+05	217157.8561	3.0	133.0	1086093.0	1.010410e+09
8	209610	407443	09/08/2015	6	OnCurb	Alive	Good	Gleditsia triacanthos var. inermis	honeylocust	None	None	NoDamage	TreesCount Staff	None	No	No	No	No	No	No	No	No	No	65 JEROME AVENUE	10305	Staten Island	502	5	Staten Island	50	64	23	SI14	Grasmere-Arrochar-Ft. Wadsworth	5006400	New York	40.596579	-74.076255	9.630732e+05	156635.5542	NaN	NaN	NaN	NaN
9	192755	207508	08/31/2015	21	OffsetFromCurb	Alive	Fair	Platanus x acerifolia	London planetree	None	None	NoDamage	TreesCount Staff	None	No	No	No	No	No	No	No	No	No	638 AVENUE Z	11223	Brooklyn	313	3	Brooklyn	47	45	23	BK26	Gravesend	3037402	New York	40.586357	-73.969744	9.926537e+05	152903.6306	47.0	37402.0	3320727.0	3.072350e+09

Last rows

	tree_id	block_id	created_at	tree_dbh	curb_loc	status	health	spc_latin	spc_common	steward	guards	sidewalk	user_type	problems	root_stone	root_grate	root_other	trunk_wire	trnk_light	trnk_other	brch_light	brch_shoe	brch_other	address	postcode	zip_city	community board	borocode	borough	cncldist	st_assem	st_senate	nta	nta_name	boro_ct	state	latitude	longitude	x_sp	y_sp	council district	census tract	bin	bbl
683778	200671	229928	09/03/2015	29	OnCurb	Alive	Good	Platanus x acerifolia	London planetree	None	None	Damage	TreesCount Staff	Stones,BranchLights	Yes	No	No	No	No	No	Yes	No	No	1040 EAST 16 STREET	11230	Brooklyn	314	3	Brooklyn	44	48	17	BK43	Midwood	3053200	New York	40.624296	-73.960344	9.952583e+05	166726.7165	44.0	532.0	3180008.0	3.067170e+09
683779	193070	210437	08/31/2015	27	OnCurb	Alive	Good	Platanus x acerifolia	London planetree	None	None	NoDamage	TreesCount Staff	Stones,WiresRope,BranchLights	Yes	No	No	Yes	No	No	Yes	No	No	2720 QUENTIN ROAD	11229	Brooklyn	315	3	Brooklyn	48	41	17	BK44	Madison	3054800	New York	40.609541	-73.945835	9.992893e+05	161353.2295	48.0	548.0	3183517.0	3.068100e+09
683780	195173	304371	09/01/2015	15	OnCurb	Alive	Fair	Platanus x acerifolia	London planetree	None	Helpful	NoDamage	TreesCount Staff	None	No	No	No	No	No	No	No	No	No	50-017 SKILLMAN AVENUE	11377	Woodside	402	4	Queens	26	30	12	QN31	Hunters Point-Sunnyside-West Maspeth	4016900	New York	40.746122	-73.913657	1.008175e+06	211120.9420	26.0	169.0	4000947.0	4.001290e+09
683781	155348	230784	08/18/2015	20	OnCurb	Alive	Good	Quercus palustris	pin oak	None	None	NoDamage	TreesCount Staff	Stones	Yes	No	No	No	No	No	No	No	No	1040 FLATBUSH AVENUE	11226	Brooklyn	314	3	Brooklyn	40	42	21	BK42	Flatbush	3051001	New York	40.645694	-73.958179	9.958556e+05	174522.7192	40.0	51001.0	3328218.0	3.051250e+09
683782	184210	504308	08/29/2015	3	OnCurb	Alive	Good	Quercus palustris	pin oak	1or2	None	NoDamage	Volunteer	None	No	No	No	No	No	No	No	No	No	2185 VALENTINE AVENUE	10457	Bronx	205	2	Bronx	15	86	33	BX41	Mount Hope	2038100	New York	40.854570	-73.899192	1.012137e+06	250636.4824	15.0	381.0	2013548.0	2.031490e+09
683783	155433	217978	08/18/2015	25	OnCurb	Alive	Good	Quercus palustris	pin oak	None	None	Damage	Volunteer	None	No	No	No	No	No	No	No	No	No	32 MARCY AVENUE	11211	Brooklyn	301	3	Brooklyn	34	53	18	BK73	North Side-South Side	3051900	New York	40.713211	-73.954944	9.967407e+05	199121.6363	34.0	519.0	3062513.0	3.023690e+09
683784	183795	348185	08/29/2015	7	OnCurb	Alive	Good	Cladrastis kentukea	Kentucky yellowwood	1or2	None	NoDamage	Volunteer	None	No	No	No	No	No	No	No	No	No	67-035 SELFRIDGE STREET	11375	Forest Hills	406	4	Queens	29	28	15	QN17	Forest Hills	4070700	New York	40.715194	-73.856650	1.023989e+06	199873.6475	29.0	707.0	4075448.0	4.031810e+09
683785	166161	401670	08/22/2015	12	OnCurb	Alive	Good	Acer rubrum	red maple	None	None	Damage	Volunteer	None	No	No	No	No	No	No	No	No	No	130 BIDWELL AVENUE	10314	Staten Island	501	5	Staten Island	50	63	24	SI07	Westerleigh	5020100	New York	40.620762	-74.136517	9.463514e+05	165466.0763	50.0	201.0	5011657.0	5.004080e+09
683786	184028	504204	08/29/2015	9	OnCurb	Alive	Good	Acer rubrum	red maple	None	None	NoDamage	TreesCount Staff	None	No	No	No	No	No	No	No	No	No	1985 ANTHONY AVENUE	10457	Bronx	205	2	Bronx	15	86	33	BX41	Mount Hope	2023502	New York	40.850828	-73.903115	1.011054e+06	249271.9507	15.0	23502.0	2007757.0	2.028120e+09
683787	200607	306527	09/03/2015	23	OnCurb	Alive	Fair	Acer rubrum	red maple	None	None	NoDamage	TreesCount Staff	None	No	No	No	No	No	No	No	No	No	69-069 183 STREET	11365	Fresh Meadows	408	4	Queens	24	25	11	QN41	Fresh Meadows-Utopia	4134100	New York	40.732165	-73.787526	1.043136e+06	206095.5383	24.0	1341.0	4153657.0	4.071360e+09

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most occurring scripts

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most occurring scripts

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most occurring scripts

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Uppercase Letter characters

Most frequent Dash Punctuation characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most occurring scripts

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most occurring scripts